package com.smbms.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fasterxml.jackson.annotation.ObjectIdGenerators;
import com.smbms.pojo.Bill;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface BillMapper extends BaseMapper<Bill> {

    /**
     * 通过查询条件获取供应商列表-模糊查询-getBillList
     */
    public List<Bill> getBillList(Bill bill);

    @Select("select b.* ,p.proName as providerName from smbms_bill as b ,smbms_provider as p where b.providerId=p.id and b.id=#{id}")
    public Bill getBillById(String id);
}
